/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50624
 Source Host           : localhost:3306
 Source Schema         : chenfeng

 Target Server Type    : MySQL
 Target Server Version : 50624
 File Encoding         : 65001

 Date: 07/09/2023 10:59:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `aid` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录的头像',
  `level` int(11) NULL DEFAULT NULL COMMENT '0:超级管理员 1:管理员',
  PRIMARY KEY (`aid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'admin', '123456', '超级管理员', 'https://pic.cnblogs.com/avatar/2120285/20200807112845.png', 0), (2, 'wenyuan', '123456', '文渊', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fl8K12uHFd6ZUJUrHl8tFVxskhjJ', 0), (5, 'xiaojin', '123456', '阿花', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjkU72CfCG5Z1n-Z44jzNdVuqrSt', 1), (6, 'luoluo', '123456', '萝萝', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjkU72CfCG5Z1n-Z44jzNdVuqrSt', 1), (7, 'chenjin', '123456', '陈锦', 'http://s08vr7vdh.hn-bkt.clouddn.com/FioQ_WWtF_yiFIJHwVkhw5aq9Vsw', 1);
COMMIT;

-- ----------------------------
-- Table structure for clazz
-- ----------------------------
DROP TABLE IF EXISTS `clazz`;
CREATE TABLE `clazz`  (
  `cid` int(11) NOT NULL AUTO_INCREMENT COMMENT '班级ID',
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级名称',
  `count` int(11) NULL DEFAULT NULL COMMENT '班级人数',
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级学科',
  PRIMARY KEY (`cid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of clazz
-- ----------------------------
BEGIN;
INSERT INTO `clazz` VALUES (1, '1班', 38, 'web'), (2, '2班', 49, 'java'), (3, '3班', 51, '物联网'), (4, '4班', 21, 'UI'), (5, '5班', 42, 'Python'), (6, '6班', 39, '云计算'), (19, '7班', 37, 'UI'), (27, '8班', 38, '大数据'), (28, '9班', 39, '嵌入式');
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `sid` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生编号',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生密码',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像地址',
  `sname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
  `gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生性别',
  `age` int(255) NULL DEFAULT NULL COMMENT '学生年龄',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `clazzid` int(255) NULL DEFAULT NULL COMMENT '班级ID',
  PRIMARY KEY (`sid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` VALUES (1, 'zhangsan', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/FhFPABYC3dPVK1MSUeuhPl8pATBe', '张三', '男', 18, '123@qq.com', 1), (2, 'lisi', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fmcr_nKEJ0WQWw5XgKIlsKwf_lJt', '李四', '男', 15, '123@qq.com', 2), (3, 'wangwu', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fq5cPCVGJKPrRor3Jjb-uxMqodxf', '王五', '男', 11, '11@qq.com', 3), (4, 'zhoaliu', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjtCiV1w0veC8gD0jI6ZjRvFzZsK', '赵六', '男', 11, '11@qq.com', 4), (5, 'tianqi', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fhft1AtvnDUlvYGJKpLnAocp-hxU', '田七', '男', 11, '11@qq.com', 5), (6, 'wangba', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fo5Watdi-EFYbhpsyiVz8lPxN5lP', '王八', '男', 33, '2211@qq.com', 6), (7, 'wenjiu', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/FvAx3bc6_cblJE2xwMV_IzQmcGBA', '九妹', '男', 11, '11@qq.com', 19), (8, 'chenjin', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fok3CvUyAuCxkgZaiz23BJ02MWQV', '陈锦', '男', 12, '11@qq.com', 1), (9, '1111', '111', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fok3CvUyAuCxkgZaiz23BJ02MWQV', '333', '男', 33, '2211@qq.com', 1), (10, '2222', '33', 'http://s08vr7vdh.hn-bkt.clouddn.com/FhWsoSgTnuJjbeDUbAG_d1iEK0Ry', '44', '男', 44, '2211@qq.com', 2), (11, '333', '5555', 'http://s08vr7vdh.hn-bkt.clouddn.com/FiTHMACXfVcwE4PpHWQOG37xFdvF', '66', '男', 66, '2211@qq.com', 3), (12, '444', '55', 'http://s08vr7vdh.hn-bkt.clouddn.com/FpcWTkNmN5EQaZ1GJTr4XMDEm_BB', '55', '男', 55, '2211@qq.com', 4), (13, '555', '55', 'http://s08vr7vdh.hn-bkt.clouddn.com/Fqe9TpZ0e1JJQjh-2W-XsUUTUVvD', '555', '男', 55, '2211@qq.com', 5), (14, '666', '55', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjgTswBZnzllTrPTQc61YFRtf2jK', '66', '男', 66, '2211@qq.com', 6), (15, '777', '5555555', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjgTswBZnzllTrPTQc61YFRtf2jK', '55', '女', 66, '123@qq.com', 7), (16, '888', '33', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjgTswBZnzllTrPTQc61YFRtf2jK', '55', '男', 44, '2211@qq.com', 1), (22, 'wenyuan', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/FjgTswBZnzllTrPTQc61YFRtf2jK', '文渊', '男', 18, '371900521@qq.com', 1), (23, 'wenwen', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/FnEc25oO4zbTN4uFE56ERpCazbX0', '文雯', '男', 18, '1234@qq.com', 27), (24, 'wenwen', '123456', 'http://s08vr7vdh.hn-bkt.clouddn.com/FnEc25oO4zbTN4uFE56ERpCazbX0', '文雯', '女', 18, '1234@qq.com', 27);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
